package com.his.registration.mapper;

import com.his.dto.DisposalCharge;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * @BelongsProject: workspace-idea
 * @BelongsPackage: com.his.registration.mapper
 * @Author: ZhangYing
 * @Date: 2023/7/2 16:08
 * @Description:
 */
@Mapper
public interface DisposalRequestMapper {
    //查询患者所有的处置费用
    @Select("select d.id,m.tech_name,m.tech_price,m.tech_type,d.creation_time,d.disposal_state from disposal_request d,medical_technology m where d.register_id=17 and d.medical_technology_id=m.id")
    public List<DisposalCharge> getDisposalFee(int registerId);

    //缴费
    @Select("update disposal_request set disposal_state=#{drugState} where id=#{id}")
    public int charge(String drugState,int id);
}
